import pandas as pd
from pandas import DataFrame

s1 = pd.Series(data=['铜仁市','铜仁市'],name='市州')
s2 = pd.Series(data=['松桃县','石阡县'],name='区县')
s3 = pd.Series(data=[1,1],name='总投资小于500')

s4 = pd.Series(data=['贵阳市','铜仁市','铜仁市'],name='市州')
s5 = pd.Series(data=['市本级','松桃县','市本级'],name='区县')
s6 = pd.Series(data=[3,1,1],name='总投资500')


df1 = pd.DataFrame({s1.name:s1,s2.name:s2,s3.name:s3})
df1 = df1.set_index(['市州','区县'])

df2 = pd.DataFrame({s4.name:s4,s5.name:s5,s6.name:s6})
df2 = df2.set_index(['市州','区县'])



df = pd.merge(right=df1,left=df2,how="outer",on=['市州','区县'])

pd.concat()

df1.to_excel(rf'')
df2.to_excel(rf'')
df.to_excel(rf'')